package com.winter.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CooperatorConfExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CooperatorConfExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCooperatorIdIsNull() {
            addCriterion("cooperator_id is null");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdIsNotNull() {
            addCriterion("cooperator_id is not null");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdEqualTo(String value) {
            addCriterion("cooperator_id =", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdNotEqualTo(String value) {
            addCriterion("cooperator_id <>", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdGreaterThan(String value) {
            addCriterion("cooperator_id >", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdGreaterThanOrEqualTo(String value) {
            addCriterion("cooperator_id >=", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdLessThan(String value) {
            addCriterion("cooperator_id <", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdLessThanOrEqualTo(String value) {
            addCriterion("cooperator_id <=", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdLike(String value) {
            addCriterion("cooperator_id like", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdNotLike(String value) {
            addCriterion("cooperator_id not like", value, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdIn(List<String> values) {
            addCriterion("cooperator_id in", values, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdNotIn(List<String> values) {
            addCriterion("cooperator_id not in", values, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdBetween(String value1, String value2) {
            addCriterion("cooperator_id between", value1, value2, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorIdNotBetween(String value1, String value2) {
            addCriterion("cooperator_id not between", value1, value2, "cooperatorId");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameIsNull() {
            addCriterion("cooperator_name is null");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameIsNotNull() {
            addCriterion("cooperator_name is not null");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameEqualTo(String value) {
            addCriterion("cooperator_name =", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameNotEqualTo(String value) {
            addCriterion("cooperator_name <>", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameGreaterThan(String value) {
            addCriterion("cooperator_name >", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameGreaterThanOrEqualTo(String value) {
            addCriterion("cooperator_name >=", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameLessThan(String value) {
            addCriterion("cooperator_name <", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameLessThanOrEqualTo(String value) {
            addCriterion("cooperator_name <=", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameLike(String value) {
            addCriterion("cooperator_name like", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameNotLike(String value) {
            addCriterion("cooperator_name not like", value, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameIn(List<String> values) {
            addCriterion("cooperator_name in", values, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameNotIn(List<String> values) {
            addCriterion("cooperator_name not in", values, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameBetween(String value1, String value2) {
            addCriterion("cooperator_name between", value1, value2, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorNameNotBetween(String value1, String value2) {
            addCriterion("cooperator_name not between", value1, value2, "cooperatorName");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeIsNull() {
            addCriterion("cooperator_type is null");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeIsNotNull() {
            addCriterion("cooperator_type is not null");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeEqualTo(Integer value) {
            addCriterion("cooperator_type =", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeNotEqualTo(Integer value) {
            addCriterion("cooperator_type <>", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeGreaterThan(Integer value) {
            addCriterion("cooperator_type >", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("cooperator_type >=", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeLessThan(Integer value) {
            addCriterion("cooperator_type <", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeLessThanOrEqualTo(Integer value) {
            addCriterion("cooperator_type <=", value, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeIn(List<Integer> values) {
            addCriterion("cooperator_type in", values, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeNotIn(List<Integer> values) {
            addCriterion("cooperator_type not in", values, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeBetween(Integer value1, Integer value2) {
            addCriterion("cooperator_type between", value1, value2, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andCooperatorTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("cooperator_type not between", value1, value2, "cooperatorType");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeIsNull() {
            addCriterion("is_restrict_distribute is null");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeIsNotNull() {
            addCriterion("is_restrict_distribute is not null");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeEqualTo(Integer value) {
            addCriterion("is_restrict_distribute =", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeNotEqualTo(Integer value) {
            addCriterion("is_restrict_distribute <>", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeGreaterThan(Integer value) {
            addCriterion("is_restrict_distribute >", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_restrict_distribute >=", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeLessThan(Integer value) {
            addCriterion("is_restrict_distribute <", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeLessThanOrEqualTo(Integer value) {
            addCriterion("is_restrict_distribute <=", value, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeIn(List<Integer> values) {
            addCriterion("is_restrict_distribute in", values, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeNotIn(List<Integer> values) {
            addCriterion("is_restrict_distribute not in", values, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeBetween(Integer value1, Integer value2) {
            addCriterion("is_restrict_distribute between", value1, value2, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsRestrictDistributeNotBetween(Integer value1, Integer value2) {
            addCriterion("is_restrict_distribute not between", value1, value2, "isRestrictDistribute");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsIsNull() {
            addCriterion("is_verify_cards is null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsIsNotNull() {
            addCriterion("is_verify_cards is not null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsEqualTo(Integer value) {
            addCriterion("is_verify_cards =", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsNotEqualTo(Integer value) {
            addCriterion("is_verify_cards <>", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsGreaterThan(Integer value) {
            addCriterion("is_verify_cards >", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_verify_cards >=", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsLessThan(Integer value) {
            addCriterion("is_verify_cards <", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsLessThanOrEqualTo(Integer value) {
            addCriterion("is_verify_cards <=", value, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsIn(List<Integer> values) {
            addCriterion("is_verify_cards in", values, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsNotIn(List<Integer> values) {
            addCriterion("is_verify_cards not in", values, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsBetween(Integer value1, Integer value2) {
            addCriterion("is_verify_cards between", value1, value2, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifyCardsNotBetween(Integer value1, Integer value2) {
            addCriterion("is_verify_cards not between", value1, value2, "isVerifyCards");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignIsNull() {
            addCriterion("is_verify_sign is null");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignIsNotNull() {
            addCriterion("is_verify_sign is not null");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignEqualTo(Integer value) {
            addCriterion("is_verify_sign =", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignNotEqualTo(Integer value) {
            addCriterion("is_verify_sign <>", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignGreaterThan(Integer value) {
            addCriterion("is_verify_sign >", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_verify_sign >=", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignLessThan(Integer value) {
            addCriterion("is_verify_sign <", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignLessThanOrEqualTo(Integer value) {
            addCriterion("is_verify_sign <=", value, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignIn(List<Integer> values) {
            addCriterion("is_verify_sign in", values, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignNotIn(List<Integer> values) {
            addCriterion("is_verify_sign not in", values, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignBetween(Integer value1, Integer value2) {
            addCriterion("is_verify_sign between", value1, value2, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsVerifySignNotBetween(Integer value1, Integer value2) {
            addCriterion("is_verify_sign not between", value1, value2, "isVerifySign");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceIsNull() {
            addCriterion("is_invoice is null");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceIsNotNull() {
            addCriterion("is_invoice is not null");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceEqualTo(Integer value) {
            addCriterion("is_invoice =", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceNotEqualTo(Integer value) {
            addCriterion("is_invoice <>", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceGreaterThan(Integer value) {
            addCriterion("is_invoice >", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_invoice >=", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceLessThan(Integer value) {
            addCriterion("is_invoice <", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceLessThanOrEqualTo(Integer value) {
            addCriterion("is_invoice <=", value, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceIn(List<Integer> values) {
            addCriterion("is_invoice in", values, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceNotIn(List<Integer> values) {
            addCriterion("is_invoice not in", values, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceBetween(Integer value1, Integer value2) {
            addCriterion("is_invoice between", value1, value2, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsInvoiceNotBetween(Integer value1, Integer value2) {
            addCriterion("is_invoice not between", value1, value2, "isInvoice");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionIsNull() {
            addCriterion("is_return_commission is null");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionIsNotNull() {
            addCriterion("is_return_commission is not null");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionEqualTo(Integer value) {
            addCriterion("is_return_commission =", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionNotEqualTo(Integer value) {
            addCriterion("is_return_commission <>", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionGreaterThan(Integer value) {
            addCriterion("is_return_commission >", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_return_commission >=", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionLessThan(Integer value) {
            addCriterion("is_return_commission <", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionLessThanOrEqualTo(Integer value) {
            addCriterion("is_return_commission <=", value, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionIn(List<Integer> values) {
            addCriterion("is_return_commission in", values, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionNotIn(List<Integer> values) {
            addCriterion("is_return_commission not in", values, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionBetween(Integer value1, Integer value2) {
            addCriterion("is_return_commission between", value1, value2, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andIsReturnCommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("is_return_commission not between", value1, value2, "isReturnCommission");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdIsNull() {
            addCriterion("upper_agent_id is null");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdIsNotNull() {
            addCriterion("upper_agent_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdEqualTo(String value) {
            addCriterion("upper_agent_id =", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdNotEqualTo(String value) {
            addCriterion("upper_agent_id <>", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdGreaterThan(String value) {
            addCriterion("upper_agent_id >", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("upper_agent_id >=", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdLessThan(String value) {
            addCriterion("upper_agent_id <", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdLessThanOrEqualTo(String value) {
            addCriterion("upper_agent_id <=", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdLike(String value) {
            addCriterion("upper_agent_id like", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdNotLike(String value) {
            addCriterion("upper_agent_id not like", value, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdIn(List<String> values) {
            addCriterion("upper_agent_id in", values, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdNotIn(List<String> values) {
            addCriterion("upper_agent_id not in", values, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdBetween(String value1, String value2) {
            addCriterion("upper_agent_id between", value1, value2, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andUpperAgentIdNotBetween(String value1, String value2) {
            addCriterion("upper_agent_id not between", value1, value2, "upperAgentId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdIsNull() {
            addCriterion("distribute_company_id is null");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdIsNotNull() {
            addCriterion("distribute_company_id is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdEqualTo(String value) {
            addCriterion("distribute_company_id =", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdNotEqualTo(String value) {
            addCriterion("distribute_company_id <>", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdGreaterThan(String value) {
            addCriterion("distribute_company_id >", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("distribute_company_id >=", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdLessThan(String value) {
            addCriterion("distribute_company_id <", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("distribute_company_id <=", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdLike(String value) {
            addCriterion("distribute_company_id like", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdNotLike(String value) {
            addCriterion("distribute_company_id not like", value, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdIn(List<String> values) {
            addCriterion("distribute_company_id in", values, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdNotIn(List<String> values) {
            addCriterion("distribute_company_id not in", values, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdBetween(String value1, String value2) {
            addCriterion("distribute_company_id between", value1, value2, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeCompanyIdNotBetween(String value1, String value2) {
            addCriterion("distribute_company_id not between", value1, value2, "distributeCompanyId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdIsNull() {
            addCriterion("distribute_channel_id is null");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdIsNotNull() {
            addCriterion("distribute_channel_id is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdEqualTo(String value) {
            addCriterion("distribute_channel_id =", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdNotEqualTo(String value) {
            addCriterion("distribute_channel_id <>", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdGreaterThan(String value) {
            addCriterion("distribute_channel_id >", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("distribute_channel_id >=", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdLessThan(String value) {
            addCriterion("distribute_channel_id <", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdLessThanOrEqualTo(String value) {
            addCriterion("distribute_channel_id <=", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdLike(String value) {
            addCriterion("distribute_channel_id like", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdNotLike(String value) {
            addCriterion("distribute_channel_id not like", value, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdIn(List<String> values) {
            addCriterion("distribute_channel_id in", values, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdNotIn(List<String> values) {
            addCriterion("distribute_channel_id not in", values, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdBetween(String value1, String value2) {
            addCriterion("distribute_channel_id between", value1, value2, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andDistributeChannelIdNotBetween(String value1, String value2) {
            addCriterion("distribute_channel_id not between", value1, value2, "distributeChannelId");
            return (Criteria) this;
        }

        public Criteria andProtocolNameIsNull() {
            addCriterion("protocol_name is null");
            return (Criteria) this;
        }

        public Criteria andProtocolNameIsNotNull() {
            addCriterion("protocol_name is not null");
            return (Criteria) this;
        }

        public Criteria andProtocolNameEqualTo(String value) {
            addCriterion("protocol_name =", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameNotEqualTo(String value) {
            addCriterion("protocol_name <>", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameGreaterThan(String value) {
            addCriterion("protocol_name >", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameGreaterThanOrEqualTo(String value) {
            addCriterion("protocol_name >=", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameLessThan(String value) {
            addCriterion("protocol_name <", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameLessThanOrEqualTo(String value) {
            addCriterion("protocol_name <=", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameLike(String value) {
            addCriterion("protocol_name like", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameNotLike(String value) {
            addCriterion("protocol_name not like", value, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameIn(List<String> values) {
            addCriterion("protocol_name in", values, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameNotIn(List<String> values) {
            addCriterion("protocol_name not in", values, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameBetween(String value1, String value2) {
            addCriterion("protocol_name between", value1, value2, "protocolName");
            return (Criteria) this;
        }

        public Criteria andProtocolNameNotBetween(String value1, String value2) {
            addCriterion("protocol_name not between", value1, value2, "protocolName");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNull() {
            addCriterion("service_type is null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNotNull() {
            addCriterion("service_type is not null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualTo(String value) {
            addCriterion("service_type =", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualTo(String value) {
            addCriterion("service_type <>", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThan(String value) {
            addCriterion("service_type >", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("service_type >=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThan(String value) {
            addCriterion("service_type <", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualTo(String value) {
            addCriterion("service_type <=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLike(String value) {
            addCriterion("service_type like", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotLike(String value) {
            addCriterion("service_type not like", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIn(List<String> values) {
            addCriterion("service_type in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotIn(List<String> values) {
            addCriterion("service_type not in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeBetween(String value1, String value2) {
            addCriterion("service_type between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotBetween(String value1, String value2) {
            addCriterion("service_type not between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryIsNull() {
            addCriterion("invoice_category is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryIsNotNull() {
            addCriterion("invoice_category is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryEqualTo(Integer value) {
            addCriterion("invoice_category =", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryNotEqualTo(Integer value) {
            addCriterion("invoice_category <>", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryGreaterThan(Integer value) {
            addCriterion("invoice_category >", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_category >=", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryLessThan(Integer value) {
            addCriterion("invoice_category <", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_category <=", value, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryIn(List<Integer> values) {
            addCriterion("invoice_category in", values, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryNotIn(List<Integer> values) {
            addCriterion("invoice_category not in", values, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryBetween(Integer value1, Integer value2) {
            addCriterion("invoice_category between", value1, value2, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andInvoiceCategoryNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_category not between", value1, value2, "invoiceCategory");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIsNull() {
            addCriterion("payee_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIsNotNull() {
            addCriterion("payee_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeNameEqualTo(String value) {
            addCriterion("payee_name =", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotEqualTo(String value) {
            addCriterion("payee_name <>", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameGreaterThan(String value) {
            addCriterion("payee_name >", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_name >=", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLessThan(String value) {
            addCriterion("payee_name <", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLessThanOrEqualTo(String value) {
            addCriterion("payee_name <=", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameLike(String value) {
            addCriterion("payee_name like", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotLike(String value) {
            addCriterion("payee_name not like", value, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameIn(List<String> values) {
            addCriterion("payee_name in", values, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotIn(List<String> values) {
            addCriterion("payee_name not in", values, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameBetween(String value1, String value2) {
            addCriterion("payee_name between", value1, value2, "payeeName");
            return (Criteria) this;
        }

        public Criteria andPayeeNameNotBetween(String value1, String value2) {
            addCriterion("payee_name not between", value1, value2, "payeeName");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("bank_name is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("bank_name =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("bank_name <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("bank_name >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("bank_name >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("bank_name <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("bank_name <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("bank_name like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("bank_name not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("bank_name in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("bank_name not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("bank_name between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("bank_name not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("member_id like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("member_id not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNull() {
            addCriterion("account_number is null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNotNull() {
            addCriterion("account_number is not null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberEqualTo(String value) {
            addCriterion("account_number =", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotEqualTo(String value) {
            addCriterion("account_number <>", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThan(String value) {
            addCriterion("account_number >", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThanOrEqualTo(String value) {
            addCriterion("account_number >=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThan(String value) {
            addCriterion("account_number <", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThanOrEqualTo(String value) {
            addCriterion("account_number <=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLike(String value) {
            addCriterion("account_number like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotLike(String value) {
            addCriterion("account_number not like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIn(List<String> values) {
            addCriterion("account_number in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotIn(List<String> values) {
            addCriterion("account_number not in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberBetween(String value1, String value2) {
            addCriterion("account_number between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotBetween(String value1, String value2) {
            addCriterion("account_number not between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeIsNull() {
            addCriterion("industry_code is null");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeIsNotNull() {
            addCriterion("industry_code is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeEqualTo(String value) {
            addCriterion("industry_code =", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeNotEqualTo(String value) {
            addCriterion("industry_code <>", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeGreaterThan(String value) {
            addCriterion("industry_code >", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeGreaterThanOrEqualTo(String value) {
            addCriterion("industry_code >=", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeLessThan(String value) {
            addCriterion("industry_code <", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeLessThanOrEqualTo(String value) {
            addCriterion("industry_code <=", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeLike(String value) {
            addCriterion("industry_code like", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeNotLike(String value) {
            addCriterion("industry_code not like", value, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeIn(List<String> values) {
            addCriterion("industry_code in", values, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeNotIn(List<String> values) {
            addCriterion("industry_code not in", values, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeBetween(String value1, String value2) {
            addCriterion("industry_code between", value1, value2, "industryCode");
            return (Criteria) this;
        }

        public Criteria andIndustryCodeNotBetween(String value1, String value2) {
            addCriterion("industry_code not between", value1, value2, "industryCode");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("create_user is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("create_user is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("create_user =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("create_user <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("create_user >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("create_user >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("create_user <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("create_user <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("create_user like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("create_user not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("create_user in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("create_user not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("create_user between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("create_user not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverIsNull() {
            addCriterion("cooperator_lever is null");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverIsNotNull() {
            addCriterion("cooperator_lever is not null");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverEqualTo(Integer value) {
            addCriterion("cooperator_lever =", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverNotEqualTo(Integer value) {
            addCriterion("cooperator_lever <>", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverGreaterThan(Integer value) {
            addCriterion("cooperator_lever >", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverGreaterThanOrEqualTo(Integer value) {
            addCriterion("cooperator_lever >=", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverLessThan(Integer value) {
            addCriterion("cooperator_lever <", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverLessThanOrEqualTo(Integer value) {
            addCriterion("cooperator_lever <=", value, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverIn(List<Integer> values) {
            addCriterion("cooperator_lever in", values, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverNotIn(List<Integer> values) {
            addCriterion("cooperator_lever not in", values, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverBetween(Integer value1, Integer value2) {
            addCriterion("cooperator_lever between", value1, value2, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andCooperatorLeverNotBetween(Integer value1, Integer value2) {
            addCriterion("cooperator_lever not between", value1, value2, "cooperatorLever");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagIsNull() {
            addCriterion("distribute_flag is null");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagIsNotNull() {
            addCriterion("distribute_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagEqualTo(Integer value) {
            addCriterion("distribute_flag =", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagNotEqualTo(Integer value) {
            addCriterion("distribute_flag <>", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagGreaterThan(Integer value) {
            addCriterion("distribute_flag >", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("distribute_flag >=", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagLessThan(Integer value) {
            addCriterion("distribute_flag <", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("distribute_flag <=", value, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagIn(List<Integer> values) {
            addCriterion("distribute_flag in", values, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagNotIn(List<Integer> values) {
            addCriterion("distribute_flag not in", values, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagBetween(Integer value1, Integer value2) {
            addCriterion("distribute_flag between", value1, value2, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("distribute_flag not between", value1, value2, "distributeFlag");
            return (Criteria) this;
        }

        public Criteria andComputeModeIsNull() {
            addCriterion("compute_mode is null");
            return (Criteria) this;
        }

        public Criteria andComputeModeIsNotNull() {
            addCriterion("compute_mode is not null");
            return (Criteria) this;
        }

        public Criteria andComputeModeEqualTo(Integer value) {
            addCriterion("compute_mode =", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeNotEqualTo(Integer value) {
            addCriterion("compute_mode <>", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeGreaterThan(Integer value) {
            addCriterion("compute_mode >", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("compute_mode >=", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeLessThan(Integer value) {
            addCriterion("compute_mode <", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeLessThanOrEqualTo(Integer value) {
            addCriterion("compute_mode <=", value, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeIn(List<Integer> values) {
            addCriterion("compute_mode in", values, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeNotIn(List<Integer> values) {
            addCriterion("compute_mode not in", values, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeBetween(Integer value1, Integer value2) {
            addCriterion("compute_mode between", value1, value2, "computeMode");
            return (Criteria) this;
        }

        public Criteria andComputeModeNotBetween(Integer value1, Integer value2) {
            addCriterion("compute_mode not between", value1, value2, "computeMode");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagIsNull() {
            addCriterion("sms_notice_flag is null");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagIsNotNull() {
            addCriterion("sms_notice_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagEqualTo(Boolean value) {
            addCriterion("sms_notice_flag =", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagNotEqualTo(Boolean value) {
            addCriterion("sms_notice_flag <>", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagGreaterThan(Boolean value) {
            addCriterion("sms_notice_flag >", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("sms_notice_flag >=", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagLessThan(Boolean value) {
            addCriterion("sms_notice_flag <", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("sms_notice_flag <=", value, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagIn(List<Boolean> values) {
            addCriterion("sms_notice_flag in", values, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagNotIn(List<Boolean> values) {
            addCriterion("sms_notice_flag not in", values, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("sms_notice_flag between", value1, value2, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andSmsNoticeFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("sms_notice_flag not between", value1, value2, "smsNoticeFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignIsNull() {
            addCriterion("invoice_verify_sign is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignIsNotNull() {
            addCriterion("invoice_verify_sign is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignEqualTo(Integer value) {
            addCriterion("invoice_verify_sign =", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignNotEqualTo(Integer value) {
            addCriterion("invoice_verify_sign <>", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignGreaterThan(Integer value) {
            addCriterion("invoice_verify_sign >", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_verify_sign >=", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignLessThan(Integer value) {
            addCriterion("invoice_verify_sign <", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_verify_sign <=", value, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignIn(List<Integer> values) {
            addCriterion("invoice_verify_sign in", values, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignNotIn(List<Integer> values) {
            addCriterion("invoice_verify_sign not in", values, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignBetween(Integer value1, Integer value2) {
            addCriterion("invoice_verify_sign between", value1, value2, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andInvoiceVerifySignNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_verify_sign not between", value1, value2, "invoiceVerifySign");
            return (Criteria) this;
        }

        public Criteria andBatchModeIsNull() {
            addCriterion("batch_mode is null");
            return (Criteria) this;
        }

        public Criteria andBatchModeIsNotNull() {
            addCriterion("batch_mode is not null");
            return (Criteria) this;
        }

        public Criteria andBatchModeEqualTo(Integer value) {
            addCriterion("batch_mode =", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeNotEqualTo(Integer value) {
            addCriterion("batch_mode <>", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeGreaterThan(Integer value) {
            addCriterion("batch_mode >", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("batch_mode >=", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeLessThan(Integer value) {
            addCriterion("batch_mode <", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeLessThanOrEqualTo(Integer value) {
            addCriterion("batch_mode <=", value, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeIn(List<Integer> values) {
            addCriterion("batch_mode in", values, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeNotIn(List<Integer> values) {
            addCriterion("batch_mode not in", values, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeBetween(Integer value1, Integer value2) {
            addCriterion("batch_mode between", value1, value2, "batchMode");
            return (Criteria) this;
        }

        public Criteria andBatchModeNotBetween(Integer value1, Integer value2) {
            addCriterion("batch_mode not between", value1, value2, "batchMode");
            return (Criteria) this;
        }

        public Criteria andExternalDataIsNull() {
            addCriterion("external_data is null");
            return (Criteria) this;
        }

        public Criteria andExternalDataIsNotNull() {
            addCriterion("external_data is not null");
            return (Criteria) this;
        }

        public Criteria andExternalDataEqualTo(Integer value) {
            addCriterion("external_data =", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataNotEqualTo(Integer value) {
            addCriterion("external_data <>", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataGreaterThan(Integer value) {
            addCriterion("external_data >", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataGreaterThanOrEqualTo(Integer value) {
            addCriterion("external_data >=", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataLessThan(Integer value) {
            addCriterion("external_data <", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataLessThanOrEqualTo(Integer value) {
            addCriterion("external_data <=", value, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataIn(List<Integer> values) {
            addCriterion("external_data in", values, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataNotIn(List<Integer> values) {
            addCriterion("external_data not in", values, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataBetween(Integer value1, Integer value2) {
            addCriterion("external_data between", value1, value2, "externalData");
            return (Criteria) this;
        }

        public Criteria andExternalDataNotBetween(Integer value1, Integer value2) {
            addCriterion("external_data not between", value1, value2, "externalData");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagIsNull() {
            addCriterion("advance_invoice_flag is null");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagIsNotNull() {
            addCriterion("advance_invoice_flag is not null");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagEqualTo(Integer value) {
            addCriterion("advance_invoice_flag =", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagNotEqualTo(Integer value) {
            addCriterion("advance_invoice_flag <>", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagGreaterThan(Integer value) {
            addCriterion("advance_invoice_flag >", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("advance_invoice_flag >=", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagLessThan(Integer value) {
            addCriterion("advance_invoice_flag <", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagLessThanOrEqualTo(Integer value) {
            addCriterion("advance_invoice_flag <=", value, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagIn(List<Integer> values) {
            addCriterion("advance_invoice_flag in", values, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagNotIn(List<Integer> values) {
            addCriterion("advance_invoice_flag not in", values, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagBetween(Integer value1, Integer value2) {
            addCriterion("advance_invoice_flag between", value1, value2, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andAdvanceInvoiceFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("advance_invoice_flag not between", value1, value2, "advanceInvoiceFlag");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNull() {
            addCriterion("parent_id is null");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNotNull() {
            addCriterion("parent_id is not null");
            return (Criteria) this;
        }

        public Criteria andParentIdEqualTo(String value) {
            addCriterion("parent_id =", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotEqualTo(String value) {
            addCriterion("parent_id <>", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThan(String value) {
            addCriterion("parent_id >", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThanOrEqualTo(String value) {
            addCriterion("parent_id >=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThan(String value) {
            addCriterion("parent_id <", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLessThanOrEqualTo(String value) {
            addCriterion("parent_id <=", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdLike(String value) {
            addCriterion("parent_id like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotLike(String value) {
            addCriterion("parent_id not like", value, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdIn(List<String> values) {
            addCriterion("parent_id in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotIn(List<String> values) {
            addCriterion("parent_id not in", values, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdBetween(String value1, String value2) {
            addCriterion("parent_id between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andParentIdNotBetween(String value1, String value2) {
            addCriterion("parent_id not between", value1, value2, "parentId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdIsNull() {
            addCriterion("business_manager_id is null");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdIsNotNull() {
            addCriterion("business_manager_id is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdEqualTo(String value) {
            addCriterion("business_manager_id =", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdNotEqualTo(String value) {
            addCriterion("business_manager_id <>", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdGreaterThan(String value) {
            addCriterion("business_manager_id >", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdGreaterThanOrEqualTo(String value) {
            addCriterion("business_manager_id >=", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdLessThan(String value) {
            addCriterion("business_manager_id <", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdLessThanOrEqualTo(String value) {
            addCriterion("business_manager_id <=", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdLike(String value) {
            addCriterion("business_manager_id like", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdNotLike(String value) {
            addCriterion("business_manager_id not like", value, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdIn(List<String> values) {
            addCriterion("business_manager_id in", values, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdNotIn(List<String> values) {
            addCriterion("business_manager_id not in", values, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdBetween(String value1, String value2) {
            addCriterion("business_manager_id between", value1, value2, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andBusinessManagerIdNotBetween(String value1, String value2) {
            addCriterion("business_manager_id not between", value1, value2, "businessManagerId");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagIsNull() {
            addCriterion("distribute_sign_flag is null");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagIsNotNull() {
            addCriterion("distribute_sign_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagEqualTo(Integer value) {
            addCriterion("distribute_sign_flag =", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagNotEqualTo(Integer value) {
            addCriterion("distribute_sign_flag <>", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagGreaterThan(Integer value) {
            addCriterion("distribute_sign_flag >", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("distribute_sign_flag >=", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagLessThan(Integer value) {
            addCriterion("distribute_sign_flag <", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagLessThanOrEqualTo(Integer value) {
            addCriterion("distribute_sign_flag <=", value, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagIn(List<Integer> values) {
            addCriterion("distribute_sign_flag in", values, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagNotIn(List<Integer> values) {
            addCriterion("distribute_sign_flag not in", values, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagBetween(Integer value1, Integer value2) {
            addCriterion("distribute_sign_flag between", value1, value2, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andDistributeSignFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("distribute_sign_flag not between", value1, value2, "distributeSignFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagIsNull() {
            addCriterion("charge_sms_flag is null");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagIsNotNull() {
            addCriterion("charge_sms_flag is not null");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagEqualTo(Integer value) {
            addCriterion("charge_sms_flag =", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagNotEqualTo(Integer value) {
            addCriterion("charge_sms_flag <>", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagGreaterThan(Integer value) {
            addCriterion("charge_sms_flag >", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("charge_sms_flag >=", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagLessThan(Integer value) {
            addCriterion("charge_sms_flag <", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagLessThanOrEqualTo(Integer value) {
            addCriterion("charge_sms_flag <=", value, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagIn(List<Integer> values) {
            addCriterion("charge_sms_flag in", values, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagNotIn(List<Integer> values) {
            addCriterion("charge_sms_flag not in", values, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagBetween(Integer value1, Integer value2) {
            addCriterion("charge_sms_flag between", value1, value2, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andChargeSmsFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("charge_sms_flag not between", value1, value2, "chargeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagIsNull() {
            addCriterion("email_flag is null");
            return (Criteria) this;
        }

        public Criteria andEmailFlagIsNotNull() {
            addCriterion("email_flag is not null");
            return (Criteria) this;
        }

        public Criteria andEmailFlagEqualTo(Integer value) {
            addCriterion("email_flag =", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagNotEqualTo(Integer value) {
            addCriterion("email_flag <>", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagGreaterThan(Integer value) {
            addCriterion("email_flag >", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("email_flag >=", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagLessThan(Integer value) {
            addCriterion("email_flag <", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagLessThanOrEqualTo(Integer value) {
            addCriterion("email_flag <=", value, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagIn(List<Integer> values) {
            addCriterion("email_flag in", values, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagNotIn(List<Integer> values) {
            addCriterion("email_flag not in", values, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagBetween(Integer value1, Integer value2) {
            addCriterion("email_flag between", value1, value2, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andEmailFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("email_flag not between", value1, value2, "emailFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagIsNull() {
            addCriterion("oem_flag is null");
            return (Criteria) this;
        }

        public Criteria andOemFlagIsNotNull() {
            addCriterion("oem_flag is not null");
            return (Criteria) this;
        }

        public Criteria andOemFlagEqualTo(Boolean value) {
            addCriterion("oem_flag =", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagNotEqualTo(Boolean value) {
            addCriterion("oem_flag <>", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagGreaterThan(Boolean value) {
            addCriterion("oem_flag >", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("oem_flag >=", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagLessThan(Boolean value) {
            addCriterion("oem_flag <", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("oem_flag <=", value, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagIn(List<Boolean> values) {
            addCriterion("oem_flag in", values, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagNotIn(List<Boolean> values) {
            addCriterion("oem_flag not in", values, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("oem_flag between", value1, value2, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andOemFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("oem_flag not between", value1, value2, "oemFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagIsNull() {
            addCriterion("small_distribute_flag is null");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagIsNotNull() {
            addCriterion("small_distribute_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagEqualTo(Boolean value) {
            addCriterion("small_distribute_flag =", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagNotEqualTo(Boolean value) {
            addCriterion("small_distribute_flag <>", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagGreaterThan(Boolean value) {
            addCriterion("small_distribute_flag >", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("small_distribute_flag >=", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagLessThan(Boolean value) {
            addCriterion("small_distribute_flag <", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("small_distribute_flag <=", value, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagIn(List<Boolean> values) {
            addCriterion("small_distribute_flag in", values, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagNotIn(List<Boolean> values) {
            addCriterion("small_distribute_flag not in", values, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("small_distribute_flag between", value1, value2, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andSmallDistributeFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("small_distribute_flag not between", value1, value2, "smallDistributeFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagIsNull() {
            addCriterion("deopsit_flag is null");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagIsNotNull() {
            addCriterion("deopsit_flag is not null");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagEqualTo(Integer value) {
            addCriterion("deopsit_flag =", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagNotEqualTo(Integer value) {
            addCriterion("deopsit_flag <>", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagGreaterThan(Integer value) {
            addCriterion("deopsit_flag >", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("deopsit_flag >=", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagLessThan(Integer value) {
            addCriterion("deopsit_flag <", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagLessThanOrEqualTo(Integer value) {
            addCriterion("deopsit_flag <=", value, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagIn(List<Integer> values) {
            addCriterion("deopsit_flag in", values, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagNotIn(List<Integer> values) {
            addCriterion("deopsit_flag not in", values, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagBetween(Integer value1, Integer value2) {
            addCriterion("deopsit_flag between", value1, value2, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andDeopsitFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("deopsit_flag not between", value1, value2, "deopsitFlag");
            return (Criteria) this;
        }

        public Criteria andUscCodeIsNull() {
            addCriterion("usc_code is null");
            return (Criteria) this;
        }

        public Criteria andUscCodeIsNotNull() {
            addCriterion("usc_code is not null");
            return (Criteria) this;
        }

        public Criteria andUscCodeEqualTo(String value) {
            addCriterion("usc_code =", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeNotEqualTo(String value) {
            addCriterion("usc_code <>", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeGreaterThan(String value) {
            addCriterion("usc_code >", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeGreaterThanOrEqualTo(String value) {
            addCriterion("usc_code >=", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeLessThan(String value) {
            addCriterion("usc_code <", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeLessThanOrEqualTo(String value) {
            addCriterion("usc_code <=", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeLike(String value) {
            addCriterion("usc_code like", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeNotLike(String value) {
            addCriterion("usc_code not like", value, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeIn(List<String> values) {
            addCriterion("usc_code in", values, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeNotIn(List<String> values) {
            addCriterion("usc_code not in", values, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeBetween(String value1, String value2) {
            addCriterion("usc_code between", value1, value2, "uscCode");
            return (Criteria) this;
        }

        public Criteria andUscCodeNotBetween(String value1, String value2) {
            addCriterion("usc_code not between", value1, value2, "uscCode");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIsNull() {
            addCriterion("legal_person is null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIsNotNull() {
            addCriterion("legal_person is not null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonEqualTo(String value) {
            addCriterion("legal_person =", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotEqualTo(String value) {
            addCriterion("legal_person <>", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonGreaterThan(String value) {
            addCriterion("legal_person >", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonGreaterThanOrEqualTo(String value) {
            addCriterion("legal_person >=", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLessThan(String value) {
            addCriterion("legal_person <", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLessThanOrEqualTo(String value) {
            addCriterion("legal_person <=", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonLike(String value) {
            addCriterion("legal_person like", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotLike(String value) {
            addCriterion("legal_person not like", value, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIn(List<String> values) {
            addCriterion("legal_person in", values, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotIn(List<String> values) {
            addCriterion("legal_person not in", values, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonBetween(String value1, String value2) {
            addCriterion("legal_person between", value1, value2, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonNotBetween(String value1, String value2) {
            addCriterion("legal_person not between", value1, value2, "legalPerson");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardIsNull() {
            addCriterion("legal_person_id_card is null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardIsNotNull() {
            addCriterion("legal_person_id_card is not null");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardEqualTo(String value) {
            addCriterion("legal_person_id_card =", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardNotEqualTo(String value) {
            addCriterion("legal_person_id_card <>", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardGreaterThan(String value) {
            addCriterion("legal_person_id_card >", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("legal_person_id_card >=", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardLessThan(String value) {
            addCriterion("legal_person_id_card <", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardLessThanOrEqualTo(String value) {
            addCriterion("legal_person_id_card <=", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardLike(String value) {
            addCriterion("legal_person_id_card like", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardNotLike(String value) {
            addCriterion("legal_person_id_card not like", value, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardIn(List<String> values) {
            addCriterion("legal_person_id_card in", values, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardNotIn(List<String> values) {
            addCriterion("legal_person_id_card not in", values, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardBetween(String value1, String value2) {
            addCriterion("legal_person_id_card between", value1, value2, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andLegalPersonIdCardNotBetween(String value1, String value2) {
            addCriterion("legal_person_id_card not between", value1, value2, "legalPersonIdCard");
            return (Criteria) this;
        }

        public Criteria andGenderIsNull() {
            addCriterion("gender is null");
            return (Criteria) this;
        }

        public Criteria andGenderIsNotNull() {
            addCriterion("gender is not null");
            return (Criteria) this;
        }

        public Criteria andGenderEqualTo(Integer value) {
            addCriterion("gender =", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotEqualTo(Integer value) {
            addCriterion("gender <>", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThan(Integer value) {
            addCriterion("gender >", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThanOrEqualTo(Integer value) {
            addCriterion("gender >=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThan(Integer value) {
            addCriterion("gender <", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThanOrEqualTo(Integer value) {
            addCriterion("gender <=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderIn(List<Integer> values) {
            addCriterion("gender in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotIn(List<Integer> values) {
            addCriterion("gender not in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderBetween(Integer value1, Integer value2) {
            addCriterion("gender between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotBetween(Integer value1, Integer value2) {
            addCriterion("gender not between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeIsNull() {
            addCriterion("contract_signing_time is null");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeIsNotNull() {
            addCriterion("contract_signing_time is not null");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeEqualTo(String value) {
            addCriterion("contract_signing_time =", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeNotEqualTo(String value) {
            addCriterion("contract_signing_time <>", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeGreaterThan(String value) {
            addCriterion("contract_signing_time >", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeGreaterThanOrEqualTo(String value) {
            addCriterion("contract_signing_time >=", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeLessThan(String value) {
            addCriterion("contract_signing_time <", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeLessThanOrEqualTo(String value) {
            addCriterion("contract_signing_time <=", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeLike(String value) {
            addCriterion("contract_signing_time like", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeNotLike(String value) {
            addCriterion("contract_signing_time not like", value, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeIn(List<String> values) {
            addCriterion("contract_signing_time in", values, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeNotIn(List<String> values) {
            addCriterion("contract_signing_time not in", values, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeBetween(String value1, String value2) {
            addCriterion("contract_signing_time between", value1, value2, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andContractSigningTimeNotBetween(String value1, String value2) {
            addCriterion("contract_signing_time not between", value1, value2, "contractSigningTime");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagIsNull() {
            addCriterion("automatic_renewal_flag is null");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagIsNotNull() {
            addCriterion("automatic_renewal_flag is not null");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagEqualTo(Integer value) {
            addCriterion("automatic_renewal_flag =", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagNotEqualTo(Integer value) {
            addCriterion("automatic_renewal_flag <>", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagGreaterThan(Integer value) {
            addCriterion("automatic_renewal_flag >", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("automatic_renewal_flag >=", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagLessThan(Integer value) {
            addCriterion("automatic_renewal_flag <", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagLessThanOrEqualTo(Integer value) {
            addCriterion("automatic_renewal_flag <=", value, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagIn(List<Integer> values) {
            addCriterion("automatic_renewal_flag in", values, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagNotIn(List<Integer> values) {
            addCriterion("automatic_renewal_flag not in", values, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagBetween(Integer value1, Integer value2) {
            addCriterion("automatic_renewal_flag between", value1, value2, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andAutomaticRenewalFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("automatic_renewal_flag not between", value1, value2, "automaticRenewalFlag");
            return (Criteria) this;
        }

        public Criteria andSignedNumberIsNull() {
            addCriterion("signed_number is null");
            return (Criteria) this;
        }

        public Criteria andSignedNumberIsNotNull() {
            addCriterion("signed_number is not null");
            return (Criteria) this;
        }

        public Criteria andSignedNumberEqualTo(Integer value) {
            addCriterion("signed_number =", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberNotEqualTo(Integer value) {
            addCriterion("signed_number <>", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberGreaterThan(Integer value) {
            addCriterion("signed_number >", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("signed_number >=", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberLessThan(Integer value) {
            addCriterion("signed_number <", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberLessThanOrEqualTo(Integer value) {
            addCriterion("signed_number <=", value, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberIn(List<Integer> values) {
            addCriterion("signed_number in", values, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberNotIn(List<Integer> values) {
            addCriterion("signed_number not in", values, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberBetween(Integer value1, Integer value2) {
            addCriterion("signed_number between", value1, value2, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSignedNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("signed_number not between", value1, value2, "signedNumber");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagIsNull() {
            addCriterion("single_rate_flag is null");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagIsNotNull() {
            addCriterion("single_rate_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagEqualTo(Integer value) {
            addCriterion("single_rate_flag =", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagNotEqualTo(Integer value) {
            addCriterion("single_rate_flag <>", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagGreaterThan(Integer value) {
            addCriterion("single_rate_flag >", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_rate_flag >=", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagLessThan(Integer value) {
            addCriterion("single_rate_flag <", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagLessThanOrEqualTo(Integer value) {
            addCriterion("single_rate_flag <=", value, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagIn(List<Integer> values) {
            addCriterion("single_rate_flag in", values, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagNotIn(List<Integer> values) {
            addCriterion("single_rate_flag not in", values, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagBetween(Integer value1, Integer value2) {
            addCriterion("single_rate_flag between", value1, value2, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andSingleRateFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("single_rate_flag not between", value1, value2, "singleRateFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagIsNull() {
            addCriterion("xw_bank_trust_flag is null");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagIsNotNull() {
            addCriterion("xw_bank_trust_flag is not null");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagEqualTo(Boolean value) {
            addCriterion("xw_bank_trust_flag =", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagNotEqualTo(Boolean value) {
            addCriterion("xw_bank_trust_flag <>", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagGreaterThan(Boolean value) {
            addCriterion("xw_bank_trust_flag >", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("xw_bank_trust_flag >=", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagLessThan(Boolean value) {
            addCriterion("xw_bank_trust_flag <", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("xw_bank_trust_flag <=", value, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagIn(List<Boolean> values) {
            addCriterion("xw_bank_trust_flag in", values, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagNotIn(List<Boolean> values) {
            addCriterion("xw_bank_trust_flag not in", values, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("xw_bank_trust_flag between", value1, value2, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andXwBankTrustFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("xw_bank_trust_flag not between", value1, value2, "xwBankTrustFlag");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileIsNull() {
            addCriterion("company_mobile is null");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileIsNotNull() {
            addCriterion("company_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileEqualTo(String value) {
            addCriterion("company_mobile =", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileNotEqualTo(String value) {
            addCriterion("company_mobile <>", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileGreaterThan(String value) {
            addCriterion("company_mobile >", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileGreaterThanOrEqualTo(String value) {
            addCriterion("company_mobile >=", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileLessThan(String value) {
            addCriterion("company_mobile <", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileLessThanOrEqualTo(String value) {
            addCriterion("company_mobile <=", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileLike(String value) {
            addCriterion("company_mobile like", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileNotLike(String value) {
            addCriterion("company_mobile not like", value, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileIn(List<String> values) {
            addCriterion("company_mobile in", values, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileNotIn(List<String> values) {
            addCriterion("company_mobile not in", values, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileBetween(String value1, String value2) {
            addCriterion("company_mobile between", value1, value2, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andCompanyMobileNotBetween(String value1, String value2) {
            addCriterion("company_mobile not between", value1, value2, "companyMobile");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyIsNull() {
            addCriterion("relation_factoring_company is null");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyIsNotNull() {
            addCriterion("relation_factoring_company is not null");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyEqualTo(String value) {
            addCriterion("relation_factoring_company =", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyNotEqualTo(String value) {
            addCriterion("relation_factoring_company <>", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyGreaterThan(String value) {
            addCriterion("relation_factoring_company >", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("relation_factoring_company >=", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyLessThan(String value) {
            addCriterion("relation_factoring_company <", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyLessThanOrEqualTo(String value) {
            addCriterion("relation_factoring_company <=", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyLike(String value) {
            addCriterion("relation_factoring_company like", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyNotLike(String value) {
            addCriterion("relation_factoring_company not like", value, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyIn(List<String> values) {
            addCriterion("relation_factoring_company in", values, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyNotIn(List<String> values) {
            addCriterion("relation_factoring_company not in", values, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyBetween(String value1, String value2) {
            addCriterion("relation_factoring_company between", value1, value2, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andRelationFactoringCompanyNotBetween(String value1, String value2) {
            addCriterion("relation_factoring_company not between", value1, value2, "relationFactoringCompany");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagIsNull() {
            addCriterion("worker_cfca_sign_flag is null");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagIsNotNull() {
            addCriterion("worker_cfca_sign_flag is not null");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagEqualTo(Boolean value) {
            addCriterion("worker_cfca_sign_flag =", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagNotEqualTo(Boolean value) {
            addCriterion("worker_cfca_sign_flag <>", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagGreaterThan(Boolean value) {
            addCriterion("worker_cfca_sign_flag >", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("worker_cfca_sign_flag >=", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagLessThan(Boolean value) {
            addCriterion("worker_cfca_sign_flag <", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("worker_cfca_sign_flag <=", value, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagIn(List<Boolean> values) {
            addCriterion("worker_cfca_sign_flag in", values, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagNotIn(List<Boolean> values) {
            addCriterion("worker_cfca_sign_flag not in", values, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("worker_cfca_sign_flag between", value1, value2, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("worker_cfca_sign_flag not between", value1, value2, "workerCfcaSignFlag");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02IsNull() {
            addCriterion("worker_cfca_sign_flag_02 is null");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02IsNotNull() {
            addCriterion("worker_cfca_sign_flag_02 is not null");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02EqualTo(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 =", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02NotEqualTo(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 <>", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02GreaterThan(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 >", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02GreaterThanOrEqualTo(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 >=", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02LessThan(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 <", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02LessThanOrEqualTo(Integer value) {
            addCriterion("worker_cfca_sign_flag_02 <=", value, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02In(List<Integer> values) {
            addCriterion("worker_cfca_sign_flag_02 in", values, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02NotIn(List<Integer> values) {
            addCriterion("worker_cfca_sign_flag_02 not in", values, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02Between(Integer value1, Integer value2) {
            addCriterion("worker_cfca_sign_flag_02 between", value1, value2, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andWorkerCfcaSignFlag02NotBetween(Integer value1, Integer value2) {
            addCriterion("worker_cfca_sign_flag_02 not between", value1, value2, "workerCfcaSignFlag02");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeIsNull() {
            addCriterion("economics_type is null");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeIsNotNull() {
            addCriterion("economics_type is not null");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeEqualTo(String value) {
            addCriterion("economics_type =", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeNotEqualTo(String value) {
            addCriterion("economics_type <>", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeGreaterThan(String value) {
            addCriterion("economics_type >", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeGreaterThanOrEqualTo(String value) {
            addCriterion("economics_type >=", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeLessThan(String value) {
            addCriterion("economics_type <", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeLessThanOrEqualTo(String value) {
            addCriterion("economics_type <=", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeLike(String value) {
            addCriterion("economics_type like", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeNotLike(String value) {
            addCriterion("economics_type not like", value, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeIn(List<String> values) {
            addCriterion("economics_type in", values, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeNotIn(List<String> values) {
            addCriterion("economics_type not in", values, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeBetween(String value1, String value2) {
            addCriterion("economics_type between", value1, value2, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsTypeNotBetween(String value1, String value2) {
            addCriterion("economics_type not between", value1, value2, "economicsType");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameIsNull() {
            addCriterion("economics_name is null");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameIsNotNull() {
            addCriterion("economics_name is not null");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameEqualTo(String value) {
            addCriterion("economics_name =", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameNotEqualTo(String value) {
            addCriterion("economics_name <>", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameGreaterThan(String value) {
            addCriterion("economics_name >", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameGreaterThanOrEqualTo(String value) {
            addCriterion("economics_name >=", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameLessThan(String value) {
            addCriterion("economics_name <", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameLessThanOrEqualTo(String value) {
            addCriterion("economics_name <=", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameLike(String value) {
            addCriterion("economics_name like", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameNotLike(String value) {
            addCriterion("economics_name not like", value, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameIn(List<String> values) {
            addCriterion("economics_name in", values, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameNotIn(List<String> values) {
            addCriterion("economics_name not in", values, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameBetween(String value1, String value2) {
            addCriterion("economics_name between", value1, value2, "economicsName");
            return (Criteria) this;
        }

        public Criteria andEconomicsNameNotBetween(String value1, String value2) {
            addCriterion("economics_name not between", value1, value2, "economicsName");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNull() {
            addCriterion("province_id is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNotNull() {
            addCriterion("province_id is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdEqualTo(String value) {
            addCriterion("province_id =", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotEqualTo(String value) {
            addCriterion("province_id <>", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThan(String value) {
            addCriterion("province_id >", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThanOrEqualTo(String value) {
            addCriterion("province_id >=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThan(String value) {
            addCriterion("province_id <", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThanOrEqualTo(String value) {
            addCriterion("province_id <=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLike(String value) {
            addCriterion("province_id like", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotLike(String value) {
            addCriterion("province_id not like", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIn(List<String> values) {
            addCriterion("province_id in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotIn(List<String> values) {
            addCriterion("province_id not in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdBetween(String value1, String value2) {
            addCriterion("province_id between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotBetween(String value1, String value2) {
            addCriterion("province_id not between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("city_id is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("city_id is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(String value) {
            addCriterion("city_id =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(String value) {
            addCriterion("city_id <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(String value) {
            addCriterion("city_id >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(String value) {
            addCriterion("city_id >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(String value) {
            addCriterion("city_id <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(String value) {
            addCriterion("city_id <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLike(String value) {
            addCriterion("city_id like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotLike(String value) {
            addCriterion("city_id not like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<String> values) {
            addCriterion("city_id in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<String> values) {
            addCriterion("city_id not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(String value1, String value2) {
            addCriterion("city_id between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(String value1, String value2) {
            addCriterion("city_id not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIsNull() {
            addCriterion("district_id is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIsNotNull() {
            addCriterion("district_id is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictIdEqualTo(String value) {
            addCriterion("district_id =", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotEqualTo(String value) {
            addCriterion("district_id <>", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdGreaterThan(String value) {
            addCriterion("district_id >", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdGreaterThanOrEqualTo(String value) {
            addCriterion("district_id >=", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdLessThan(String value) {
            addCriterion("district_id <", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdLessThanOrEqualTo(String value) {
            addCriterion("district_id <=", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdLike(String value) {
            addCriterion("district_id like", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotLike(String value) {
            addCriterion("district_id not like", value, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdIn(List<String> values) {
            addCriterion("district_id in", values, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotIn(List<String> values) {
            addCriterion("district_id not in", values, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdBetween(String value1, String value2) {
            addCriterion("district_id between", value1, value2, "districtId");
            return (Criteria) this;
        }

        public Criteria andDistrictIdNotBetween(String value1, String value2) {
            addCriterion("district_id not between", value1, value2, "districtId");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNull() {
            addCriterion("province_name is null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIsNotNull() {
            addCriterion("province_name is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceNameEqualTo(String value) {
            addCriterion("province_name =", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotEqualTo(String value) {
            addCriterion("province_name <>", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThan(String value) {
            addCriterion("province_name >", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameGreaterThanOrEqualTo(String value) {
            addCriterion("province_name >=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThan(String value) {
            addCriterion("province_name <", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLessThanOrEqualTo(String value) {
            addCriterion("province_name <=", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameLike(String value) {
            addCriterion("province_name like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotLike(String value) {
            addCriterion("province_name not like", value, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameIn(List<String> values) {
            addCriterion("province_name in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotIn(List<String> values) {
            addCriterion("province_name not in", values, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameBetween(String value1, String value2) {
            addCriterion("province_name between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andProvinceNameNotBetween(String value1, String value2) {
            addCriterion("province_name not between", value1, value2, "provinceName");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("city_name is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("city_name is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("city_name =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("city_name <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("city_name >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("city_name >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("city_name <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("city_name <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("city_name like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("city_name not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("city_name in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("city_name not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("city_name between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("city_name not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameIsNull() {
            addCriterion("district_name is null");
            return (Criteria) this;
        }

        public Criteria andDistrictNameIsNotNull() {
            addCriterion("district_name is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictNameEqualTo(String value) {
            addCriterion("district_name =", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameNotEqualTo(String value) {
            addCriterion("district_name <>", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameGreaterThan(String value) {
            addCriterion("district_name >", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameGreaterThanOrEqualTo(String value) {
            addCriterion("district_name >=", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameLessThan(String value) {
            addCriterion("district_name <", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameLessThanOrEqualTo(String value) {
            addCriterion("district_name <=", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameLike(String value) {
            addCriterion("district_name like", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameNotLike(String value) {
            addCriterion("district_name not like", value, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameIn(List<String> values) {
            addCriterion("district_name in", values, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameNotIn(List<String> values) {
            addCriterion("district_name not in", values, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameBetween(String value1, String value2) {
            addCriterion("district_name between", value1, value2, "districtName");
            return (Criteria) this;
        }

        public Criteria andDistrictNameNotBetween(String value1, String value2) {
            addCriterion("district_name not between", value1, value2, "districtName");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagIsNull() {
            addCriterion("open_api_protocol_flag is null");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagIsNotNull() {
            addCriterion("open_api_protocol_flag is not null");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagEqualTo(Boolean value) {
            addCriterion("open_api_protocol_flag =", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagNotEqualTo(Boolean value) {
            addCriterion("open_api_protocol_flag <>", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagGreaterThan(Boolean value) {
            addCriterion("open_api_protocol_flag >", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("open_api_protocol_flag >=", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagLessThan(Boolean value) {
            addCriterion("open_api_protocol_flag <", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("open_api_protocol_flag <=", value, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagIn(List<Boolean> values) {
            addCriterion("open_api_protocol_flag in", values, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagNotIn(List<Boolean> values) {
            addCriterion("open_api_protocol_flag not in", values, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("open_api_protocol_flag between", value1, value2, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andOpenApiProtocolFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("open_api_protocol_flag not between", value1, value2, "openApiProtocolFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagIsNull() {
            addCriterion("quarterly_restrict_flag is null");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagIsNotNull() {
            addCriterion("quarterly_restrict_flag is not null");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagEqualTo(Boolean value) {
            addCriterion("quarterly_restrict_flag =", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagNotEqualTo(Boolean value) {
            addCriterion("quarterly_restrict_flag <>", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagGreaterThan(Boolean value) {
            addCriterion("quarterly_restrict_flag >", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("quarterly_restrict_flag >=", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagLessThan(Boolean value) {
            addCriterion("quarterly_restrict_flag <", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("quarterly_restrict_flag <=", value, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagIn(List<Boolean> values) {
            addCriterion("quarterly_restrict_flag in", values, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagNotIn(List<Boolean> values) {
            addCriterion("quarterly_restrict_flag not in", values, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("quarterly_restrict_flag between", value1, value2, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andQuarterlyRestrictFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("quarterly_restrict_flag not between", value1, value2, "quarterlyRestrictFlag");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelIsNull() {
            addCriterion("mbk_co_lab_model is null");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelIsNotNull() {
            addCriterion("mbk_co_lab_model is not null");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelEqualTo(String value) {
            addCriterion("mbk_co_lab_model =", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelNotEqualTo(String value) {
            addCriterion("mbk_co_lab_model <>", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelGreaterThan(String value) {
            addCriterion("mbk_co_lab_model >", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelGreaterThanOrEqualTo(String value) {
            addCriterion("mbk_co_lab_model >=", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelLessThan(String value) {
            addCriterion("mbk_co_lab_model <", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelLessThanOrEqualTo(String value) {
            addCriterion("mbk_co_lab_model <=", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelLike(String value) {
            addCriterion("mbk_co_lab_model like", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelNotLike(String value) {
            addCriterion("mbk_co_lab_model not like", value, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelIn(List<String> values) {
            addCriterion("mbk_co_lab_model in", values, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelNotIn(List<String> values) {
            addCriterion("mbk_co_lab_model not in", values, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelBetween(String value1, String value2) {
            addCriterion("mbk_co_lab_model between", value1, value2, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andMbkCoLabModelNotBetween(String value1, String value2) {
            addCriterion("mbk_co_lab_model not between", value1, value2, "mbkCoLabModel");
            return (Criteria) this;
        }

        public Criteria andSystemTypeIsNull() {
            addCriterion("system_type is null");
            return (Criteria) this;
        }

        public Criteria andSystemTypeIsNotNull() {
            addCriterion("system_type is not null");
            return (Criteria) this;
        }

        public Criteria andSystemTypeEqualTo(Integer value) {
            addCriterion("system_type =", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeNotEqualTo(Integer value) {
            addCriterion("system_type <>", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeGreaterThan(Integer value) {
            addCriterion("system_type >", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("system_type >=", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeLessThan(Integer value) {
            addCriterion("system_type <", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeLessThanOrEqualTo(Integer value) {
            addCriterion("system_type <=", value, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeIn(List<Integer> values) {
            addCriterion("system_type in", values, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeNotIn(List<Integer> values) {
            addCriterion("system_type not in", values, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeBetween(Integer value1, Integer value2) {
            addCriterion("system_type between", value1, value2, "systemType");
            return (Criteria) this;
        }

        public Criteria andSystemTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("system_type not between", value1, value2, "systemType");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodIsNull() {
            addCriterion("task_affrim_method is null");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodIsNotNull() {
            addCriterion("task_affrim_method is not null");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodEqualTo(Integer value) {
            addCriterion("task_affrim_method =", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodNotEqualTo(Integer value) {
            addCriterion("task_affrim_method <>", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodGreaterThan(Integer value) {
            addCriterion("task_affrim_method >", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("task_affrim_method >=", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodLessThan(Integer value) {
            addCriterion("task_affrim_method <", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodLessThanOrEqualTo(Integer value) {
            addCriterion("task_affrim_method <=", value, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodIn(List<Integer> values) {
            addCriterion("task_affrim_method in", values, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodNotIn(List<Integer> values) {
            addCriterion("task_affrim_method not in", values, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodBetween(Integer value1, Integer value2) {
            addCriterion("task_affrim_method between", value1, value2, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andTaskAffrimMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("task_affrim_method not between", value1, value2, "taskAffrimMethod");
            return (Criteria) this;
        }

        public Criteria andSpreadUserIsNull() {
            addCriterion("spread_user is null");
            return (Criteria) this;
        }

        public Criteria andSpreadUserIsNotNull() {
            addCriterion("spread_user is not null");
            return (Criteria) this;
        }

        public Criteria andSpreadUserEqualTo(String value) {
            addCriterion("spread_user =", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserNotEqualTo(String value) {
            addCriterion("spread_user <>", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserGreaterThan(String value) {
            addCriterion("spread_user >", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserGreaterThanOrEqualTo(String value) {
            addCriterion("spread_user >=", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserLessThan(String value) {
            addCriterion("spread_user <", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserLessThanOrEqualTo(String value) {
            addCriterion("spread_user <=", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserLike(String value) {
            addCriterion("spread_user like", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserNotLike(String value) {
            addCriterion("spread_user not like", value, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserIn(List<String> values) {
            addCriterion("spread_user in", values, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserNotIn(List<String> values) {
            addCriterion("spread_user not in", values, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserBetween(String value1, String value2) {
            addCriterion("spread_user between", value1, value2, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andSpreadUserNotBetween(String value1, String value2) {
            addCriterion("spread_user not between", value1, value2, "spreadUser");
            return (Criteria) this;
        }

        public Criteria andBillingRuleIsNull() {
            addCriterion("billing_rule is null");
            return (Criteria) this;
        }

        public Criteria andBillingRuleIsNotNull() {
            addCriterion("billing_rule is not null");
            return (Criteria) this;
        }

        public Criteria andBillingRuleEqualTo(Integer value) {
            addCriterion("billing_rule =", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleNotEqualTo(Integer value) {
            addCriterion("billing_rule <>", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleGreaterThan(Integer value) {
            addCriterion("billing_rule >", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleGreaterThanOrEqualTo(Integer value) {
            addCriterion("billing_rule >=", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleLessThan(Integer value) {
            addCriterion("billing_rule <", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleLessThanOrEqualTo(Integer value) {
            addCriterion("billing_rule <=", value, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleIn(List<Integer> values) {
            addCriterion("billing_rule in", values, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleNotIn(List<Integer> values) {
            addCriterion("billing_rule not in", values, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleBetween(Integer value1, Integer value2) {
            addCriterion("billing_rule between", value1, value2, "billingRule");
            return (Criteria) this;
        }

        public Criteria andBillingRuleNotBetween(Integer value1, Integer value2) {
            addCriterion("billing_rule not between", value1, value2, "billingRule");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagIsNull() {
            addCriterion("approval_flag is null");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagIsNotNull() {
            addCriterion("approval_flag is not null");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagEqualTo(Boolean value) {
            addCriterion("approval_flag =", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagNotEqualTo(Boolean value) {
            addCriterion("approval_flag <>", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagGreaterThan(Boolean value) {
            addCriterion("approval_flag >", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("approval_flag >=", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagLessThan(Boolean value) {
            addCriterion("approval_flag <", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("approval_flag <=", value, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagIn(List<Boolean> values) {
            addCriterion("approval_flag in", values, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagNotIn(List<Boolean> values) {
            addCriterion("approval_flag not in", values, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("approval_flag between", value1, value2, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("approval_flag not between", value1, value2, "approvalFlag");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIsNull() {
            addCriterion("approval_status is null");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIsNotNull() {
            addCriterion("approval_status is not null");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusEqualTo(Integer value) {
            addCriterion("approval_status =", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotEqualTo(Integer value) {
            addCriterion("approval_status <>", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusGreaterThan(Integer value) {
            addCriterion("approval_status >", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("approval_status >=", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusLessThan(Integer value) {
            addCriterion("approval_status <", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusLessThanOrEqualTo(Integer value) {
            addCriterion("approval_status <=", value, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusIn(List<Integer> values) {
            addCriterion("approval_status in", values, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotIn(List<Integer> values) {
            addCriterion("approval_status not in", values, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusBetween(Integer value1, Integer value2) {
            addCriterion("approval_status between", value1, value2, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andApprovalStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("approval_status not between", value1, value2, "approvalStatus");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdIsNull() {
            addCriterion("dding_approval_id is null");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdIsNotNull() {
            addCriterion("dding_approval_id is not null");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdEqualTo(String value) {
            addCriterion("dding_approval_id =", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdNotEqualTo(String value) {
            addCriterion("dding_approval_id <>", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdGreaterThan(String value) {
            addCriterion("dding_approval_id >", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdGreaterThanOrEqualTo(String value) {
            addCriterion("dding_approval_id >=", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdLessThan(String value) {
            addCriterion("dding_approval_id <", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdLessThanOrEqualTo(String value) {
            addCriterion("dding_approval_id <=", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdLike(String value) {
            addCriterion("dding_approval_id like", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdNotLike(String value) {
            addCriterion("dding_approval_id not like", value, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdIn(List<String> values) {
            addCriterion("dding_approval_id in", values, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdNotIn(List<String> values) {
            addCriterion("dding_approval_id not in", values, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdBetween(String value1, String value2) {
            addCriterion("dding_approval_id between", value1, value2, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDdingApprovalIdNotBetween(String value1, String value2) {
            addCriterion("dding_approval_id not between", value1, value2, "ddingApprovalId");
            return (Criteria) this;
        }

        public Criteria andDistributeModeIsNull() {
            addCriterion("distribute_mode is null");
            return (Criteria) this;
        }

        public Criteria andDistributeModeIsNotNull() {
            addCriterion("distribute_mode is not null");
            return (Criteria) this;
        }

        public Criteria andDistributeModeEqualTo(Boolean value) {
            addCriterion("distribute_mode =", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeNotEqualTo(Boolean value) {
            addCriterion("distribute_mode <>", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeGreaterThan(Boolean value) {
            addCriterion("distribute_mode >", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeGreaterThanOrEqualTo(Boolean value) {
            addCriterion("distribute_mode >=", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeLessThan(Boolean value) {
            addCriterion("distribute_mode <", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeLessThanOrEqualTo(Boolean value) {
            addCriterion("distribute_mode <=", value, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeIn(List<Boolean> values) {
            addCriterion("distribute_mode in", values, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeNotIn(List<Boolean> values) {
            addCriterion("distribute_mode not in", values, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeBetween(Boolean value1, Boolean value2) {
            addCriterion("distribute_mode between", value1, value2, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andDistributeModeNotBetween(Boolean value1, Boolean value2) {
            addCriterion("distribute_mode not between", value1, value2, "distributeMode");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryIsNull() {
            addCriterion("insurance_applicable_industry is null");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryIsNotNull() {
            addCriterion("insurance_applicable_industry is not null");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryEqualTo(String value) {
            addCriterion("insurance_applicable_industry =", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryNotEqualTo(String value) {
            addCriterion("insurance_applicable_industry <>", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryGreaterThan(String value) {
            addCriterion("insurance_applicable_industry >", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("insurance_applicable_industry >=", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryLessThan(String value) {
            addCriterion("insurance_applicable_industry <", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryLessThanOrEqualTo(String value) {
            addCriterion("insurance_applicable_industry <=", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryLike(String value) {
            addCriterion("insurance_applicable_industry like", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryNotLike(String value) {
            addCriterion("insurance_applicable_industry not like", value, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryIn(List<String> values) {
            addCriterion("insurance_applicable_industry in", values, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryNotIn(List<String> values) {
            addCriterion("insurance_applicable_industry not in", values, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryBetween(String value1, String value2) {
            addCriterion("insurance_applicable_industry between", value1, value2, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andInsuranceApplicableIndustryNotBetween(String value1, String value2) {
            addCriterion("insurance_applicable_industry not between", value1, value2, "insuranceApplicableIndustry");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(String value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeIsNull() {
            addCriterion("delivery_industry_type is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeIsNotNull() {
            addCriterion("delivery_industry_type is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeEqualTo(Integer value) {
            addCriterion("delivery_industry_type =", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeNotEqualTo(Integer value) {
            addCriterion("delivery_industry_type <>", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeGreaterThan(Integer value) {
            addCriterion("delivery_industry_type >", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_industry_type >=", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeLessThan(Integer value) {
            addCriterion("delivery_industry_type <", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_industry_type <=", value, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeIn(List<Integer> values) {
            addCriterion("delivery_industry_type in", values, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeNotIn(List<Integer> values) {
            addCriterion("delivery_industry_type not in", values, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeBetween(Integer value1, Integer value2) {
            addCriterion("delivery_industry_type between", value1, value2, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryIndustryTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_industry_type not between", value1, value2, "deliveryIndustryType");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagIsNull() {
            addCriterion("enterprise_alipay_payment_flag is null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagIsNotNull() {
            addCriterion("enterprise_alipay_payment_flag is not null");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagEqualTo(Integer value) {
            addCriterion("enterprise_alipay_payment_flag =", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagNotEqualTo(Integer value) {
            addCriterion("enterprise_alipay_payment_flag <>", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagGreaterThan(Integer value) {
            addCriterion("enterprise_alipay_payment_flag >", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("enterprise_alipay_payment_flag >=", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagLessThan(Integer value) {
            addCriterion("enterprise_alipay_payment_flag <", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagLessThanOrEqualTo(Integer value) {
            addCriterion("enterprise_alipay_payment_flag <=", value, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagIn(List<Integer> values) {
            addCriterion("enterprise_alipay_payment_flag in", values, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagNotIn(List<Integer> values) {
            addCriterion("enterprise_alipay_payment_flag not in", values, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagBetween(Integer value1, Integer value2) {
            addCriterion("enterprise_alipay_payment_flag between", value1, value2, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andEnterpriseAlipayPaymentFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("enterprise_alipay_payment_flag not between", value1, value2, "enterpriseAlipayPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdIsNull() {
            addCriterion("third_party_channel_id is null");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdIsNotNull() {
            addCriterion("third_party_channel_id is not null");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdEqualTo(String value) {
            addCriterion("third_party_channel_id =", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdNotEqualTo(String value) {
            addCriterion("third_party_channel_id <>", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdGreaterThan(String value) {
            addCriterion("third_party_channel_id >", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("third_party_channel_id >=", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdLessThan(String value) {
            addCriterion("third_party_channel_id <", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdLessThanOrEqualTo(String value) {
            addCriterion("third_party_channel_id <=", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdLike(String value) {
            addCriterion("third_party_channel_id like", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdNotLike(String value) {
            addCriterion("third_party_channel_id not like", value, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdIn(List<String> values) {
            addCriterion("third_party_channel_id in", values, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdNotIn(List<String> values) {
            addCriterion("third_party_channel_id not in", values, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdBetween(String value1, String value2) {
            addCriterion("third_party_channel_id between", value1, value2, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andThirdPartyChannelIdNotBetween(String value1, String value2) {
            addCriterion("third_party_channel_id not between", value1, value2, "thirdPartyChannelId");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagIsNull() {
            addCriterion("invoice_remind_flag is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagIsNotNull() {
            addCriterion("invoice_remind_flag is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagEqualTo(Boolean value) {
            addCriterion("invoice_remind_flag =", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagNotEqualTo(Boolean value) {
            addCriterion("invoice_remind_flag <>", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagGreaterThan(Boolean value) {
            addCriterion("invoice_remind_flag >", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("invoice_remind_flag >=", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagLessThan(Boolean value) {
            addCriterion("invoice_remind_flag <", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("invoice_remind_flag <=", value, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagIn(List<Boolean> values) {
            addCriterion("invoice_remind_flag in", values, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagNotIn(List<Boolean> values) {
            addCriterion("invoice_remind_flag not in", values, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("invoice_remind_flag between", value1, value2, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andInvoiceRemindFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("invoice_remind_flag not between", value1, value2, "invoiceRemindFlag");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryIsNull() {
            addCriterion("nucleic_acid_testing_industry is null");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryIsNotNull() {
            addCriterion("nucleic_acid_testing_industry is not null");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryEqualTo(Integer value) {
            addCriterion("nucleic_acid_testing_industry =", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryNotEqualTo(Integer value) {
            addCriterion("nucleic_acid_testing_industry <>", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryGreaterThan(Integer value) {
            addCriterion("nucleic_acid_testing_industry >", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryGreaterThanOrEqualTo(Integer value) {
            addCriterion("nucleic_acid_testing_industry >=", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryLessThan(Integer value) {
            addCriterion("nucleic_acid_testing_industry <", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryLessThanOrEqualTo(Integer value) {
            addCriterion("nucleic_acid_testing_industry <=", value, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryIn(List<Integer> values) {
            addCriterion("nucleic_acid_testing_industry in", values, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryNotIn(List<Integer> values) {
            addCriterion("nucleic_acid_testing_industry not in", values, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryBetween(Integer value1, Integer value2) {
            addCriterion("nucleic_acid_testing_industry between", value1, value2, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andNucleicAcidTestingIndustryNotBetween(Integer value1, Integer value2) {
            addCriterion("nucleic_acid_testing_industry not between", value1, value2, "nucleicAcidTestingIndustry");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagIsNull() {
            addCriterion("batch_verify_sms_flag is null");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagIsNotNull() {
            addCriterion("batch_verify_sms_flag is not null");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagEqualTo(Boolean value) {
            addCriterion("batch_verify_sms_flag =", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagNotEqualTo(Boolean value) {
            addCriterion("batch_verify_sms_flag <>", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagGreaterThan(Boolean value) {
            addCriterion("batch_verify_sms_flag >", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("batch_verify_sms_flag >=", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagLessThan(Boolean value) {
            addCriterion("batch_verify_sms_flag <", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("batch_verify_sms_flag <=", value, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagIn(List<Boolean> values) {
            addCriterion("batch_verify_sms_flag in", values, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagNotIn(List<Boolean> values) {
            addCriterion("batch_verify_sms_flag not in", values, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("batch_verify_sms_flag between", value1, value2, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchVerifySmsFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("batch_verify_sms_flag not between", value1, value2, "batchVerifySmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagIsNull() {
            addCriterion("batch_distribute_sms_flag is null");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagIsNotNull() {
            addCriterion("batch_distribute_sms_flag is not null");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagEqualTo(Boolean value) {
            addCriterion("batch_distribute_sms_flag =", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagNotEqualTo(Boolean value) {
            addCriterion("batch_distribute_sms_flag <>", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagGreaterThan(Boolean value) {
            addCriterion("batch_distribute_sms_flag >", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagGreaterThanOrEqualTo(Boolean value) {
            addCriterion("batch_distribute_sms_flag >=", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagLessThan(Boolean value) {
            addCriterion("batch_distribute_sms_flag <", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagLessThanOrEqualTo(Boolean value) {
            addCriterion("batch_distribute_sms_flag <=", value, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagIn(List<Boolean> values) {
            addCriterion("batch_distribute_sms_flag in", values, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagNotIn(List<Boolean> values) {
            addCriterion("batch_distribute_sms_flag not in", values, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagBetween(Boolean value1, Boolean value2) {
            addCriterion("batch_distribute_sms_flag between", value1, value2, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andBatchDistributeSmsFlagNotBetween(Boolean value1, Boolean value2) {
            addCriterion("batch_distribute_sms_flag not between", value1, value2, "batchDistributeSmsFlag");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeIsNull() {
            addCriterion("company_subject_type is null");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeIsNotNull() {
            addCriterion("company_subject_type is not null");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeEqualTo(Integer value) {
            addCriterion("company_subject_type =", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeNotEqualTo(Integer value) {
            addCriterion("company_subject_type <>", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeGreaterThan(Integer value) {
            addCriterion("company_subject_type >", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("company_subject_type >=", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeLessThan(Integer value) {
            addCriterion("company_subject_type <", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeLessThanOrEqualTo(Integer value) {
            addCriterion("company_subject_type <=", value, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeIn(List<Integer> values) {
            addCriterion("company_subject_type in", values, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeNotIn(List<Integer> values) {
            addCriterion("company_subject_type not in", values, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeBetween(Integer value1, Integer value2) {
            addCriterion("company_subject_type between", value1, value2, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanySubjectTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("company_subject_type not between", value1, value2, "companySubjectType");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoIsNull() {
            addCriterion("is_verify_id_card_photo is null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoIsNotNull() {
            addCriterion("is_verify_id_card_photo is not null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoEqualTo(Boolean value) {
            addCriterion("is_verify_id_card_photo =", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoNotEqualTo(Boolean value) {
            addCriterion("is_verify_id_card_photo <>", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoGreaterThan(Boolean value) {
            addCriterion("is_verify_id_card_photo >", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_verify_id_card_photo >=", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoLessThan(Boolean value) {
            addCriterion("is_verify_id_card_photo <", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoLessThanOrEqualTo(Boolean value) {
            addCriterion("is_verify_id_card_photo <=", value, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoIn(List<Boolean> values) {
            addCriterion("is_verify_id_card_photo in", values, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoNotIn(List<Boolean> values) {
            addCriterion("is_verify_id_card_photo not in", values, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoBetween(Boolean value1, Boolean value2) {
            addCriterion("is_verify_id_card_photo between", value1, value2, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIdCardPhotoNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_verify_id_card_photo not between", value1, value2, "isVerifyIdCardPhoto");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}